Time zone resolution and how to adjust the time zone in Linux preface today we found that the Centos 6.0-64bit system time in Vmware differs from the host time for several hours, after adjusting the system time, restart and restore the system. So I
Summary:GMT/UTC/CST;/etc/localtime,/usr/share/zoneinfo/* time zone file,/etc/profile plus TZ variable;Hardware time RTC, system time; date,hwclock,tzselect;NTP relay SERVER;RPM–IVH ntp-*;ntpdate 0.uk.pool.ntp.org; Ntpq–p,watch
Network time Protocol (NTP) is also a new exam requirement for RHCE. Study time also by the way to review how to set up Linux time, now take out and share with youSetting up an NTP server is not difficult, but NTP itself is a very complex protocol.
1. Adjust database server timeBecause the app shook a shake activity found out of date 15 minutes, but also can continue to shake, the problem is that the database server time than the application server time is quite 18 minutes, and the app is the
remark: article reproduced from: http://www.cnblogs.com/liuyou/archive/2012/07/29/2614338.html
Summary:
GMT/UTC/CST;
/etc/localtime,/usr/share/zoneinfo/* time zone file,/etc/profile plus TZ variable;
Hardware time RTC, system time;
Linux ntp time server configuration tutorial, ntp server configuration
Network Time Protocol (NTP) is also a new test requirement for RHCE. During study, I also reviewed how to set the Linux Time. Now I will share it with you.
It is not difficult
Article Source: http://www.cnblogs.com/zfc2201/p/3284965.htmlDate formatting: Alter session set nls_date_format= ' Yyyy-mm-dd hh24:mi:ss dy 'Note: The HH24 format cannot be set to am pm on PM Indicatorsysdate"function": Returns the current date.
Numeric type functions:Absolute:ABS (x) "function" returns the absolute value of x "parameter" x, numeric Expression "return" number "example" Select ABS (+), ABS ( -100) from dual;--------------------------------------------------------------------
Sysdate[Function]: returns the current date. [Parameter]: No parameter, no brackets [Return]: Date [Example] select sysdate hz from dual; return:
Add_months (d1, n1)[Function]: return the new date after the date d1 plus the n1 month. [Parameter]: d1,
Sysdate [function]: returns the current date. [Parameter]: No parameter, no brackets [Return]: Date [Example] select sysdate hz from dual; return:
Last_day (d1) [function]: return the date of the last day of the month where the date d1 is located. [
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.